Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 50000 |
| Missing cells | 254230 |
| Missing cells (%) | 23.1% |
| Total size in memory | 8.8 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Text | 14 |
|---|---|
| Numeric | 8 |
performance_title has 2215 (4.4%) missing values | Missing |
end_time has 35221 (70.4%) missing values | Missing |
postcode has 3635 (7.3%) missing values | Missing |
capacity has 27015 (54.0%) missing values | Missing |
venue_address has 28927 (57.9%) missing values | Missing |
latitude has 1904 (3.8%) missing values | Missing |
longitude has 1904 (3.8%) missing values | Missing |
duration_mins has 8442 (16.9%) missing values | Missing |
transaction_datetime has 23299 (46.6%) missing values | Missing |
audience_segment has 24378 (48.8%) missing values | Missing |
audience_subsegment has 24378 (48.8%) missing values | Missing |
membership_type has 43695 (87.4%) missing values | Missing |
has_negative_tickets has 28916 (57.8%) missing values | Missing |
ticket_count is highly skewed (γ1 = 33.44284555) | Skewed |
has_negative_tickets is highly skewed (γ1 = 22.89490082) | Skewed |
month is highly skewed (γ1 = -20.08807464) | Skewed |
has_negative_tickets has 21044 (42.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-02 20:43:26.107992 |
|---|---|
| Analysis finished | 2025-11-02 20:43:27.102663 |
| Duration | 0.99 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
performance_date
Text
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2019-08-17 |
|---|---|
| 2nd row | 2017-08-28 |
| 3rd row | 2017-08-19 |
| 4th row | 2024-08-21 |
| 5th row | 2024-08-21 |
| Value | Count | Frequency (%) |
| 2024-08-25 | 1987 | 4.0% |
| 2024-08-18 | 1689 | 3.4% |
| 2024-08-24 | 1602 | 3.2% |
| 2024-08-17 | 1466 | 2.9% |
| 2024-08-23 | 1410 | 2.8% |
| 2024-08-04 | 1389 | 2.8% |
| 2024-08-16 | 1310 | 2.6% |
| 2024-08-10 | 1305 | 2.6% |
| 2024-08-03 | 1278 | 2.6% |
| 2024-08-06 | 1273 | 2.5% |
| Other values (98) | 35291 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 118367 | |
| - | 100000 | |
| 2 | 97196 | |
| 8 | 60996 | |
| 1 | 46467 | 9.3% |
| 4 | 32813 | 6.6% |
| 7 | 13009 | 2.6% |
| 9 | 12555 | 2.5% |
| 5 | 7256 | 1.5% |
| 3 | 6194 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 500000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 118367 | |
| - | 100000 | |
| 2 | 97196 | |
| 8 | 60996 | |
| 1 | 46467 | 9.3% |
| 4 | 32813 | 6.6% |
| 7 | 13009 | 2.6% |
| 9 | 12555 | 2.5% |
| 5 | 7256 | 1.5% |
| 3 | 6194 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 500000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 118367 | |
| - | 100000 | |
| 2 | 97196 | |
| 8 | 60996 | |
| 1 | 46467 | 9.3% |
| 4 | 32813 | 6.6% |
| 7 | 13009 | 2.6% |
| 9 | 12555 | 2.5% |
| 5 | 7256 | 1.5% |
| 3 | 6194 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 500000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 118367 | |
| - | 100000 | |
| 2 | 97196 | |
| 8 | 60996 | |
| 1 | 46467 | 9.3% |
| 4 | 32813 | 6.6% |
| 7 | 13009 | 2.6% |
| 9 | 12555 | 2.5% |
| 5 | 7256 | 1.5% |
| 3 | 6194 | 1.2% |
performance_title
Text
Missing
| Distinct | 394 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 2215 |
| Missing (%) | 4.4% |
| Memory size | 781.2 KiB |
Length
| Max length | 98 |
|---|---|
| Median length | 56 |
| Mean length | 21.73223815 |
| Min length | 1 |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Eugene Onegin |
|---|---|
| 2nd row | Virgin Money Fireworks Concert |
| 3rd row | Blak Whyte Gray |
| 4th row | The Outrun |
| 5th row | Philharmonia Orchestra Residency: Fire in my mouth |
| Value | Count | Frequency (%) |
| the | 8886 | 5.5% |
| 6111 | 3.8% | |
| orchestra | 6039 | 3.7% |
| of | 3375 | 2.1% |
| symphony | 3227 | 2.0% |
| residency | 2542 | 1.6% |
| opening | 2425 | 1.5% |
| concert | 2168 | 1.3% |
| outrun | 1778 | 1.1% |
| philharmonia | 1526 | 0.9% |
| Other values (836) | 124241 |
Most occurring characters
| Value | Count | Frequency (%) |
| 114558 | 11.0% | |
| e | 95910 | 9.2% |
| a | 68230 | 6.6% |
| r | 65993 | 6.4% |
| n | 62363 | 6.0% |
| i | 58819 | 5.7% |
| o | 54844 | 5.3% |
| t | 49436 | 4.8% |
| s | 45108 | 4.3% |
| h | 42231 | 4.1% |
| Other values (84) | 380983 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1038475 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 114558 | 11.0% | |
| e | 95910 | 9.2% |
| a | 68230 | 6.6% |
| r | 65993 | 6.4% |
| n | 62363 | 6.0% |
| i | 58819 | 5.7% |
| o | 54844 | 5.3% |
| t | 49436 | 4.8% |
| s | 45108 | 4.3% |
| h | 42231 | 4.1% |
| Other values (84) | 380983 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1038475 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 114558 | 11.0% | |
| e | 95910 | 9.2% |
| a | 68230 | 6.6% |
| r | 65993 | 6.4% |
| n | 62363 | 6.0% |
| i | 58819 | 5.7% |
| o | 54844 | 5.3% |
| t | 49436 | 4.8% |
| s | 45108 | 4.3% |
| h | 42231 | 4.1% |
| Other values (84) | 380983 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1038475 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 114558 | 11.0% | |
| e | 95910 | 9.2% |
| a | 68230 | 6.6% |
| r | 65993 | 6.4% |
| n | 62363 | 6.0% |
| i | 58819 | 5.7% |
| o | 54844 | 5.3% |
| t | 49436 | 4.8% |
| s | 45108 | 4.3% |
| h | 42231 | 4.1% |
| Other values (84) | 380983 |
venue_name
Text
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.2 KiB |
Length
| Max length | 34 |
|---|---|
| Median length | 32 |
| Mean length | 13.5545 |
| Min length | 7 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Festival Theatre |
|---|---|
| 2nd row | Princes Street Gardens |
| 3rd row | The Lyceum |
| 4th row | Church Hill Theatre |
| 5th row | Usher Hall |
| Value | Count | Frequency (%) |
| hall | 23550 | |
| the | 16473 | |
| usher | 14799 | |
| theatre | 12163 | |
| queen's | 8343 | 7.4% |
| festival | 6874 | 6.1% |
| lyceum | 4547 | 4.0% |
| edinburgh | 3406 | 3.0% |
| playhouse | 3406 | 3.0% |
| church | 2620 | 2.3% |
| Other values (50) | 17010 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 95036 | |
| l | 65168 | 9.6% |
| 63191 | 9.3% | |
| h | 56588 | 8.3% |
| a | 49715 | 7.3% |
| s | 39162 | 5.8% |
| r | 37780 | 5.6% |
| H | 29336 | 4.3% |
| T | 28870 | 4.3% |
| u | 27019 | 4.0% |
| Other values (35) | 185860 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 677725 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 95036 | |
| l | 65168 | 9.6% |
| 63191 | 9.3% | |
| h | 56588 | 8.3% |
| a | 49715 | 7.3% |
| s | 39162 | 5.8% |
| r | 37780 | 5.6% |
| H | 29336 | 4.3% |
| T | 28870 | 4.3% |
| u | 27019 | 4.0% |
| Other values (35) | 185860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 677725 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 95036 | |
| l | 65168 | 9.6% |
| 63191 | 9.3% | |
| h | 56588 | 8.3% |
| a | 49715 | 7.3% |
| s | 39162 | 5.8% |
| r | 37780 | 5.6% |
| H | 29336 | 4.3% |
| T | 28870 | 4.3% |
| u | 27019 | 4.0% |
| Other values (35) | 185860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 677725 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 95036 | |
| l | 65168 | 9.6% |
| 63191 | 9.3% | |
| h | 56588 | 8.3% |
| a | 49715 | 7.3% |
| s | 39162 | 5.8% |
| r | 37780 | 5.6% |
| H | 29336 | 4.3% |
| T | 28870 | 4.3% |
| u | 27019 | 4.0% |
| Other values (35) | 185860 |
event_type
Text
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 301 |
| Missing (%) | 0.6% |
| Memory size | 781.2 KiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 11.72772088 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Opera |
|---|---|
| 2nd row | Fireworks |
| 3rd row | Dance |
| 4th row | 04. Theatre |
| 5th row | 01. Classical Music |
| Value | Count | Frequency (%) |
| classical | 21348 | |
| music | 15070 | |
| 01 | 10520 | |
| theatre | 9811 | |
| opera | 4824 | 5.2% |
| 02 | 4550 | 4.9% |
| other | 4550 | 4.9% |
| 04 | 4275 | 4.6% |
| dance | 3780 | 4.1% |
| 05 | 2698 | 2.9% |
| Other values (15) | 11541 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 63492 | 10.9% |
| s | 60357 | 10.4% |
| l | 43616 | 7.5% |
| 43268 | 7.4% | |
| c | 41011 | 7.0% |
| i | 39865 | 6.8% |
| e | 39115 | 6.7% |
| . | 26683 | 4.6% |
| 0 | 25539 | 4.4% |
| r | 23820 | 4.1% |
| Other values (28) | 176090 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 582856 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 63492 | 10.9% |
| s | 60357 | 10.4% |
| l | 43616 | 7.5% |
| 43268 | 7.4% | |
| c | 41011 | 7.0% |
| i | 39865 | 6.8% |
| e | 39115 | 6.7% |
| . | 26683 | 4.6% |
| 0 | 25539 | 4.4% |
| r | 23820 | 4.1% |
| Other values (28) | 176090 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 582856 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 63492 | 10.9% |
| s | 60357 | 10.4% |
| l | 43616 | 7.5% |
| 43268 | 7.4% | |
| c | 41011 | 7.0% |
| i | 39865 | 6.8% |
| e | 39115 | 6.7% |
| . | 26683 | 4.6% |
| 0 | 25539 | 4.4% |
| r | 23820 | 4.1% |
| Other values (28) | 176090 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 582856 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 63492 | 10.9% |
| s | 60357 | 10.4% |
| l | 43616 | 7.5% |
| 43268 | 7.4% | |
| c | 41011 | 7.0% |
| i | 39865 | 6.8% |
| e | 39115 | 6.7% |
| . | 26683 | 4.6% |
| 0 | 25539 | 4.4% |
| r | 23820 | 4.1% |
| Other values (28) | 176090 |
start_time
Text
| Distinct | 929 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.2 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 191 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 2019-08-17 19:15:00 |
|---|---|
| 2nd row | 2017-08-28 21:00:00 |
| 3rd row | 2017-08-19 14:30:00 |
| 4th row | 2024-08-21 20:00:00 |
| 5th row | 2024-08-21 20:00:00 |
| Value | Count | Frequency (%) |
| 20:00:00 | 12765 | 12.8% |
| 19:30:00 | 10372 | 10.4% |
| 11:00:00 | 7409 | 7.4% |
| 19:00:00 | 3963 | 4.0% |
| 18:00:00 | 2436 | 2.4% |
| 2024-08-25 | 1987 | 2.0% |
| 15:00:00 | 1817 | 1.8% |
| 2024-08-18 | 1689 | 1.7% |
| 2024-08-24 | 1602 | 1.6% |
| 2024-08-17 | 1466 | 1.5% |
| Other values (163) | 54494 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 311290 | |
| 2 | 115433 | 12.2% |
| - | 100000 | 10.5% |
| : | 100000 | 10.5% |
| 1 | 90258 | 9.5% |
| 8 | 63567 | 6.7% |
| 50000 | 5.3% | |
| 4 | 36886 | 3.9% |
| 9 | 28887 | 3.0% |
| 3 | 20680 | 2.2% |
| Other values (3) | 32999 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 950000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 311290 | |
| 2 | 115433 | 12.2% |
| - | 100000 | 10.5% |
| : | 100000 | 10.5% |
| 1 | 90258 | 9.5% |
| 8 | 63567 | 6.7% |
| 50000 | 5.3% | |
| 4 | 36886 | 3.9% |
| 9 | 28887 | 3.0% |
| 3 | 20680 | 2.2% |
| Other values (3) | 32999 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 950000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 311290 | |
| 2 | 115433 | 12.2% |
| - | 100000 | 10.5% |
| : | 100000 | 10.5% |
| 1 | 90258 | 9.5% |
| 8 | 63567 | 6.7% |
| 50000 | 5.3% | |
| 4 | 36886 | 3.9% |
| 9 | 28887 | 3.0% |
| 3 | 20680 | 2.2% |
| Other values (3) | 32999 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 950000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 311290 | |
| 2 | 115433 | 12.2% |
| - | 100000 | 10.5% |
| : | 100000 | 10.5% |
| 1 | 90258 | 9.5% |
| 8 | 63567 | 6.7% |
| 50000 | 5.3% | |
| 4 | 36886 | 3.9% |
| 9 | 28887 | 3.0% |
| 3 | 20680 | 2.2% |
| Other values (3) | 32999 | 3.5% |
end_time
Text
Missing
| Distinct | 435 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 35221 |
| Missing (%) | 70.4% |
| Memory size | 781.2 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 61 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 2019-08-17 22:15:00 |
|---|---|
| 2nd row | 2018-08-24 23:45:00 |
| 3rd row | 2018-08-18 16:20:00 |
| 4th row | 2018-08-21 21:45:00 |
| 5th row | 2019-08-10 20:40:00 |
| Value | Count | Frequency (%) |
| 21:30:00 | 1927 | 6.5% |
| 22:00:00 | 1712 | 5.8% |
| 12:45:00 | 1063 | 3.6% |
| 22:15:00 | 934 | 3.2% |
| 21:45:00 | 831 | 2.8% |
| 12:50:00 | 688 | 2.3% |
| 21:15:00 | 615 | 2.1% |
| 22:20:00 | 546 | 1.8% |
| 2019-08-15 | 509 | 1.7% |
| 2019-08-24 | 505 | 1.7% |
| Other values (108) | 20228 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 78634 | |
| 2 | 38586 | |
| 1 | 34183 | |
| - | 29558 | 10.5% |
| : | 29558 | 10.5% |
| 8 | 22607 | 8.1% |
| 14779 | 5.3% | |
| 9 | 9954 | 3.5% |
| 5 | 8478 | 3.0% |
| 3 | 5147 | 1.8% |
| Other values (3) | 9317 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 280801 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 78634 | |
| 2 | 38586 | |
| 1 | 34183 | |
| - | 29558 | 10.5% |
| : | 29558 | 10.5% |
| 8 | 22607 | 8.1% |
| 14779 | 5.3% | |
| 9 | 9954 | 3.5% |
| 5 | 8478 | 3.0% |
| 3 | 5147 | 1.8% |
| Other values (3) | 9317 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 280801 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 78634 | |
| 2 | 38586 | |
| 1 | 34183 | |
| - | 29558 | 10.5% |
| : | 29558 | 10.5% |
| 8 | 22607 | 8.1% |
| 14779 | 5.3% | |
| 9 | 9954 | 3.5% |
| 5 | 8478 | 3.0% |
| 3 | 5147 | 1.8% |
| Other values (3) | 9317 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 280801 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 78634 | |
| 2 | 38586 | |
| 1 | 34183 | |
| - | 29558 | 10.5% |
| : | 29558 | 10.5% |
| 8 | 22607 | 8.1% |
| 14779 | 5.3% | |
| 9 | 9954 | 3.5% |
| 5 | 8478 | 3.0% |
| 3 | 5147 | 1.8% |
| Other values (3) | 9317 | 3.3% |
ticket_count
Real number (ℝ)
Skewed
| Distinct | 219 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.1167 |
| Minimum | -22 |
|---|---|
| Maximum | 4948 |
| Zeros | 15 |
| Zeros (%) | < 0.1% |
| Negative | 40 |
| Negative (%) | 0.1% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | -22 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 6 |
| 95-th percentile | 29 |
| Maximum | 4948 |
| Range | 4970 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 90.32755937 |
|---|---|
| Coefficient of variation (CV) | 8.928559646 |
| Kurtosis | 1298.197768 |
| Mean | 10.1167 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 33.44284555 |
| Sum | 505835 |
| Variance | 8159.067982 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 16730 | |
| 1 | 12252 | |
| 4 | 3265 | 6.5% |
| 3 | 3068 | 6.1% |
| 6 | 1621 | 3.2% |
| 8 | 1152 | 2.3% |
| 5 | 1024 | 2.0% |
| 10 | 1021 | 2.0% |
| 12 | 884 | 1.8% |
| 7 | 676 | 1.4% |
| Other values (209) | 8307 |
| Value | Count | Frequency (%) |
| -22 | 2 | |
| -16 | 2 | |
| -12 | 1 | |
| -11 | 2 | |
| -9 | 1 |
| Value | Count | Frequency (%) |
| 4948 | 1 | |
| 4308 | 1 | |
| 4170 | 2 | |
| 4056 | 2 | |
| 4031 | 1 |
postcode
Text
Missing
| Distinct | 4604 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 3635 |
| Missing (%) | 7.3% |
| Memory size | 781.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 4.704561631 |
| Min length | 1 |
Unique
| Unique | 2045 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | IV2 |
|---|---|
| 2nd row | EH32 |
| 3rd row | EH5 |
| 4th row | EH6 7 |
| 5th row | SE17 3 |
| Value | Count | Frequency (%) |
| 5 | 3685 | 5.1% |
| 1 | 3540 | 4.9% |
| eh3 | 3217 | 4.5% |
| eh10 | 3075 | 4.3% |
| 6 | 3037 | 4.2% |
| eh9 | 2858 | 4.0% |
| 4 | 2689 | 3.8% |
| 2 | 2543 | 3.5% |
| eh4 | 2438 | 3.4% |
| 9 | 2122 | 3.0% |
| Other values (2160) | 42469 |
Most occurring characters
| Value | Count | Frequency (%) |
| 36810 | ||
| E | 29657 | |
| H | 29059 | |
| 1 | 25308 | |
| 2 | 10205 | 4.7% |
| 4 | 10148 | 4.7% |
| 3 | 9920 | 4.5% |
| 6 | 8708 | 4.0% |
| 5 | 8179 | 3.7% |
| 0 | 7396 | 3.4% |
| Other values (53) | 42737 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 218127 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 36810 | ||
| E | 29657 | |
| H | 29059 | |
| 1 | 25308 | |
| 2 | 10205 | 4.7% |
| 4 | 10148 | 4.7% |
| 3 | 9920 | 4.5% |
| 6 | 8708 | 4.0% |
| 5 | 8179 | 3.7% |
| 0 | 7396 | 3.4% |
| Other values (53) | 42737 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 218127 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 36810 | ||
| E | 29657 | |
| H | 29059 | |
| 1 | 25308 | |
| 2 | 10205 | 4.7% |
| 4 | 10148 | 4.7% |
| 3 | 9920 | 4.5% |
| 6 | 8708 | 4.0% |
| 5 | 8179 | 3.7% |
| 0 | 7396 | 3.4% |
| Other values (53) | 42737 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 218127 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 36810 | ||
| E | 29657 | |
| H | 29059 | |
| 1 | 25308 | |
| 2 | 10205 | 4.7% |
| 4 | 10148 | 4.7% |
| 3 | 9920 | 4.5% |
| 6 | 8708 | 4.0% |
| 5 | 8179 | 3.7% |
| 0 | 7396 | 3.4% |
| Other values (53) | 42737 |
capacity
Real number (ℝ)
Missing
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 27015 |
| Missing (%) | 54.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1848.42754 |
| Minimum | 25 |
|---|---|
| Maximum | 24672 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 190 |
| Q1 | 980 |
| median | 1887 |
| Q3 | 2376 |
| 95-th percentile | 3019 |
| Maximum | 24672 |
| Range | 24647 |
| Interquartile range (IQR) | 1396 |
Descriptive statistics
| Standard deviation | 2149.141491 |
|---|---|
| Coefficient of variation (CV) | 1.162686362 |
| Kurtosis | 47.98935712 |
| Mean | 1848.42754 |
| Median Absolute Deviation (MAD) | 598 |
| Skewness | 6.052524792 |
| Sum | 42486107 |
| Variance | 4618809.149 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2376 | 6950 | 13.9% |
| 980 | 3722 | 7.4% |
| 1887 | 3064 | 6.1% |
| 1289 | 2190 | 4.4% |
| 638 | 1897 | 3.8% |
| 3019 | 1115 | 2.2% |
| 347 | 691 | 1.4% |
| 170 | 602 | 1.2% |
| 398 | 572 | 1.1% |
| 1400 | 532 | 1.1% |
| Other values (15) | 1650 | 3.3% |
| (Missing) | 27015 |
| Value | Count | Frequency (%) |
| 25 | 141 | |
| 40 | 2 | < 0.1% |
| 45 | 141 | |
| 60 | 119 | |
| 120 | 17 | < 0.1% |
| Value | Count | Frequency (%) |
| 24672 | 67 | 0.1% |
| 15000 | 69 | 0.1% |
| 12750 | 325 | 0.7% |
| 8000 | 92 | 0.2% |
| 3019 | 1115 |
venue_address
Text
Missing
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 28927 |
| Missing (%) | 57.9% |
| Memory size | 781.2 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 38 |
| Mean length | 32.55454847 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 13-29 Nicolson St, Edinburgh EH8 9FT |
|---|---|
| 2nd row | Princes Street, Edinburgh |
| 3rd row | 30b Grindlay St, Edinburgh EH3 9AX |
| 4th row | Clerk St, Newington, Edinburgh EH8 9JG |
| 5th row | Lothian Rd, Edinburgh EH1 2EA |
| Value | Count | Frequency (%) |
| edinburgh | 21073 | |
| st | 10353 | 8.9% |
| eh1 | 8645 | 7.5% |
| rd | 7875 | 6.8% |
| eh8 | 6722 | 5.8% |
| lothian | 6649 | 5.7% |
| 2ea | 6580 | 5.7% |
| eh3 | 3858 | 3.3% |
| clerk | 3407 | 2.9% |
| 9jg | 3407 | 2.9% |
| Other values (66) | 37442 |
Most occurring characters
| Value | Count | Frequency (%) |
| 94938 | 13.8% | |
| E | 49543 | 7.2% |
| n | 44378 | 6.5% |
| i | 39579 | 5.8% |
| d | 33135 | 4.8% |
| r | 31385 | 4.6% |
| h | 28290 | 4.1% |
| g | 25529 | 3.7% |
| , | 24274 | 3.5% |
| t | 23192 | 3.4% |
| Other values (45) | 291779 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 686022 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 94938 | 13.8% | |
| E | 49543 | 7.2% |
| n | 44378 | 6.5% |
| i | 39579 | 5.8% |
| d | 33135 | 4.8% |
| r | 31385 | 4.6% |
| h | 28290 | 4.1% |
| g | 25529 | 3.7% |
| , | 24274 | 3.5% |
| t | 23192 | 3.4% |
| Other values (45) | 291779 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 686022 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 94938 | 13.8% | |
| E | 49543 | 7.2% |
| n | 44378 | 6.5% |
| i | 39579 | 5.8% |
| d | 33135 | 4.8% |
| r | 31385 | 4.6% |
| h | 28290 | 4.1% |
| g | 25529 | 3.7% |
| , | 24274 | 3.5% |
| t | 23192 | 3.4% |
| Other values (45) | 291779 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 686022 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 94938 | 13.8% | |
| E | 49543 | 7.2% |
| n | 44378 | 6.5% |
| i | 39579 | 5.8% |
| d | 33135 | 4.8% |
| r | 31385 | 4.6% |
| h | 28290 | 4.1% |
| g | 25529 | 3.7% |
| , | 24274 | 3.5% |
| t | 23192 | 3.4% |
| Other values (45) | 291779 |
latitude
Real number (ℝ)
Missing
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1904 |
| Missing (%) | 3.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.94620388 |
| Minimum | 55.901305 |
|---|---|
| Maximum | 55.975835 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 55.901305 |
|---|---|
| 5-th percentile | 55.932678 |
| Q1 | 55.942105 |
| median | 55.946994 |
| Q3 | 55.947239 |
| 95-th percentile | 55.957059 |
| Maximum | 55.975835 |
| Range | 0.07453 |
| Interquartile range (IQR) | 0.005134 |
Descriptive statistics
| Standard deviation | 0.006130014876 |
|---|---|
| Coefficient of variation (CV) | 0.0001095698091 |
| Kurtosis | 10.08293111 |
| Mean | 55.94620388 |
| Median Absolute Deviation (MAD) | 0.000245 |
| Skewness | 0.3189445554 |
| Sum | 2690788.622 |
| Variance | 3.757708239 × 10-5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 55.947239 | 14799 | |
| 55.946903 | 6805 | |
| 55.941633 | 4936 | 9.9% |
| 55.946994 | 4395 | 8.8% |
| 55.941437 | 3407 | 6.8% |
| 55.932678 | 2479 | 5.0% |
| 55.957059 | 2330 | 4.7% |
| 55.942105 | 2199 | 4.4% |
| 55.949142 | 2000 | 4.0% |
| 55.946214 | 1323 | 2.6% |
| Other values (21) | 3423 | 6.8% |
| (Missing) | 1904 | 3.8% |
| Value | Count | Frequency (%) |
| 55.901305 | 82 | 0.2% |
| 55.929731 | 16 | < 0.1% |
| 55.932678 | 2479 | |
| 55.932703 | 141 | 0.3% |
| 55.939088 | 54 | 0.1% |
| Value | Count | Frequency (%) |
| 55.975835 | 535 | 1.1% |
| 55.975724 | 1 | < 0.1% |
| 55.957059 | 2330 | |
| 55.957042 | 1076 | |
| 55.955669 | 23 | < 0.1% |
longitude
Real number (ℝ)
Missing
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1904 |
| Missing (%) | 3.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -3.196048109 |
| Minimum | -3.421135 |
|---|---|
| Maximum | -3.133686 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 48096 |
| Negative (%) | 96.2% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | -3.421135 |
|---|---|
| 5-th percentile | -3.209666 |
| Q1 | -3.205368 |
| median | -3.203251 |
| Q3 | -3.18545 |
| 95-th percentile | -3.181739 |
| Maximum | -3.133686 |
| Range | 0.287449 |
| Interquartile range (IQR) | 0.019918 |
Descriptive statistics
| Standard deviation | 0.01411397138 |
|---|---|
| Coefficient of variation (CV) | -0.00441606975 |
| Kurtosis | 107.87283 |
| Mean | -3.196048109 |
| Median Absolute Deviation (MAD) | 0.006415 |
| Skewness | -6.78994303 |
| Sum | -153717.1299 |
| Variance | 0.000199204188 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -3.205368 | 14799 | |
| -3.186007 | 6805 | |
| -3.181739 | 4936 | 9.9% |
| -3.204398 | 4395 | 8.8% |
| -3.18177 | 3407 | 6.8% |
| -3.209666 | 2479 | 5.0% |
| -3.18545 | 2330 | 4.7% |
| -3.203251 | 2199 | 4.4% |
| -3.194934 | 2000 | 4.0% |
| -3.187146 | 1323 | 2.6% |
| Other values (20) | 3423 | 6.8% |
| (Missing) | 1904 | 3.8% |
| Value | Count | Frequency (%) |
| -3.421135 | 82 | |
| -3.232348 | 54 | 0.1% |
| -3.232222 | 14 | < 0.1% |
| -3.210702 | 2 | < 0.1% |
| -3.209742 | 141 |
| Value | Count | Frequency (%) |
| -3.133686 | 16 | < 0.1% |
| -3.180622 | 536 | 1.1% |
| -3.181739 | 4936 | |
| -3.18177 | 3407 | |
| -3.185073 | 1076 | 2.2% |
duration_mins
Real number (ℝ)
Missing
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 8442 |
| Missing (%) | 16.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 111.9885461 |
| Minimum | 0 |
|---|---|
| Maximum | 405 |
| Zeros | 22 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 90 |
| median | 105 |
| Q3 | 120 |
| 95-th percentile | 210 |
| Maximum | 405 |
| Range | 405 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 44.74289517 |
|---|---|
| Coefficient of variation (CV) | 0.3995309942 |
| Kurtosis | 7.309162269 |
| Mean | 111.9885461 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 1.989315015 |
| Sum | 4654020 |
| Variance | 2001.926668 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 9258 | |
| 105 | 4861 | |
| 120 | 4392 | |
| 60 | 2653 | 5.3% |
| 75 | 2401 | 4.8% |
| 110 | 2182 | 4.4% |
| 180 | 2003 | 4.0% |
| 70 | 1957 | 3.9% |
| 210 | 1574 | 3.1% |
| 150 | 1323 | 2.6% |
| Other values (27) | 8954 | |
| (Missing) | 8442 |
| Value | Count | Frequency (%) |
| 0 | 22 | < 0.1% |
| 30 | 339 | |
| 40 | 35 | 0.1% |
| 45 | 29 | 0.1% |
| 50 | 372 |
| Value | Count | Frequency (%) |
| 405 | 25 | 0.1% |
| 385 | 137 | |
| 345 | 23 | < 0.1% |
| 330 | 140 | |
| 285 | 52 | 0.1% |
transaction_datetime
Text
Missing
| Distinct | 20403 |
|---|---|
| Distinct (%) | 76.4% |
| Missing | 23299 |
| Missing (%) | 46.6% |
| Memory size | 781.2 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Unique
| Unique | 17558 ? |
|---|---|
| Unique (%) | 65.8% |
Sample
| 1st row | 2024-05-19 20:34:59 |
|---|---|
| 2nd row | 2024-07-31 00:41:04 |
| 3rd row | 2024-05-26 11:59:07 |
| 4th row | 2024-08-05 15:24:09 |
| 5th row | 2024-03-21 12:07:59 |
| Value | Count | Frequency (%) |
| 2024-03-21 | 2506 | 4.7% |
| 2024-03-19 | 2344 | 4.4% |
| 2024-03-18 | 997 | 1.9% |
| 2024-03-15 | 588 | 1.1% |
| 2024-08-06 | 443 | 0.8% |
| 2024-03-22 | 412 | 0.8% |
| 2024-08-02 | 406 | 0.8% |
| 2024-08-05 | 405 | 0.8% |
| 2024-03-25 | 400 | 0.7% |
| 2024-08-03 | 400 | 0.7% |
| Other values (17022) | 44501 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 90071 | |
| 0 | 81025 | |
| - | 53402 | |
| : | 53402 | |
| 1 | 52857 | |
| 4 | 46566 | |
| 3 | 29899 | 5.9% |
| 26701 | 5.3% | |
| 5 | 19861 | 3.9% |
| 8 | 17380 | 3.4% |
| Other values (3) | 36155 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 507319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 90071 | |
| 0 | 81025 | |
| - | 53402 | |
| : | 53402 | |
| 1 | 52857 | |
| 4 | 46566 | |
| 3 | 29899 | 5.9% |
| 26701 | 5.3% | |
| 5 | 19861 | 3.9% |
| 8 | 17380 | 3.4% |
| Other values (3) | 36155 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 507319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 90071 | |
| 0 | 81025 | |
| - | 53402 | |
| : | 53402 | |
| 1 | 52857 | |
| 4 | 46566 | |
| 3 | 29899 | 5.9% |
| 26701 | 5.3% | |
| 5 | 19861 | 3.9% |
| 8 | 17380 | 3.4% |
| Other values (3) | 36155 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 507319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 90071 | |
| 0 | 81025 | |
| - | 53402 | |
| : | 53402 | |
| 1 | 52857 | |
| 4 | 46566 | |
| 3 | 29899 | 5.9% |
| 26701 | 5.3% | |
| 5 | 19861 | 3.9% |
| 8 | 17380 | 3.4% |
| Other values (3) | 36155 |
audience_segment
Text
Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 24378 |
| Missing (%) | 48.8% |
| Memory size | 781.2 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 5 |
| Mean length | 6.958317071 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Plays/Drama |
|---|---|
| 2nd row | Music |
| 3rd row | Other Artforms |
| 4th row | Children/Family |
| 5th row | Music |
| Value | Count | Frequency (%) |
| music | 16357 | |
| plays/drama | 3712 | 13.2% |
| dance | 2290 | 8.2% |
| other | 1203 | 4.3% |
| artforms | 1203 | 4.3% |
| outdoor | 1144 | 4.1% |
| arts | 1144 | 4.1% |
| children/family | 825 | 2.9% |
| not | 91 | 0.3% |
| applicable | 91 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 22416 | |
| c | 18738 | |
| i | 18098 | |
| u | 17501 | |
| M | 16357 | 9.2% |
| a | 14342 | 8.0% |
| r | 10434 | 5.9% |
| D | 6002 | 3.4% |
| m | 5740 | 3.2% |
| l | 5544 | 3.1% |
| Other values (18) | 43114 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 178286 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 22416 | |
| c | 18738 | |
| i | 18098 | |
| u | 17501 | |
| M | 16357 | 9.2% |
| a | 14342 | 8.0% |
| r | 10434 | 5.9% |
| D | 6002 | 3.4% |
| m | 5740 | 3.2% |
| l | 5544 | 3.1% |
| Other values (18) | 43114 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 178286 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 22416 | |
| c | 18738 | |
| i | 18098 | |
| u | 17501 | |
| M | 16357 | 9.2% |
| a | 14342 | 8.0% |
| r | 10434 | 5.9% |
| D | 6002 | 3.4% |
| m | 5740 | 3.2% |
| l | 5544 | 3.1% |
| Other values (18) | 43114 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 178286 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 22416 | |
| c | 18738 | |
| i | 18098 | |
| u | 17501 | |
| M | 16357 | 9.2% |
| a | 14342 | 8.0% |
| r | 10434 | 5.9% |
| D | 6002 | 3.4% |
| m | 5740 | 3.2% |
| l | 5544 | 3.1% |
| Other values (18) | 43114 |
audience_subsegment
Text
Missing
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 24378 |
| Missing (%) | 48.8% |
| Memory size | 781.2 KiB |
Length
| Max length | 23 |
|---|---|
| Median length | 18 |
| Mean length | 13.59804075 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Drama New Writing |
|---|---|
| 2nd row | Contemporary Classical |
| 3rd row | Other Talks |
| 4th row | C&F Plays/Drama |
| 5th row | World Music |
| Value | Count | Frequency (%) |
| 5371 | 9.6% | |
| opera | 3556 | 6.4% |
| recitals | 3537 | 6.3% |
| chamber | 3537 | 6.3% |
| orchestral | 3449 | 6.2% |
| other | 2752 | 4.9% |
| drama | 2669 | 4.8% |
| new | 2669 | 4.8% |
| writing | 2669 | 4.8% |
| contemporary | 2646 | 4.7% |
| Other values (28) | 23071 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 33871 | 9.7% |
| a | 33689 | 9.7% |
| 30304 | 8.7% | |
| e | 27577 | 7.9% |
| t | 18645 | 5.4% |
| i | 15523 | 4.5% |
| c | 15168 | 4.4% |
| s | 14436 | 4.1% |
| l | 14256 | 4.1% |
| o | 13729 | 3.9% |
| Other values (35) | 131211 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 348409 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 33871 | 9.7% |
| a | 33689 | 9.7% |
| 30304 | 8.7% | |
| e | 27577 | 7.9% |
| t | 18645 | 5.4% |
| i | 15523 | 4.5% |
| c | 15168 | 4.4% |
| s | 14436 | 4.1% |
| l | 14256 | 4.1% |
| o | 13729 | 3.9% |
| Other values (35) | 131211 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 348409 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 33871 | 9.7% |
| a | 33689 | 9.7% |
| 30304 | 8.7% | |
| e | 27577 | 7.9% |
| t | 18645 | 5.4% |
| i | 15523 | 4.5% |
| c | 15168 | 4.4% |
| s | 14436 | 4.1% |
| l | 14256 | 4.1% |
| o | 13729 | 3.9% |
| Other values (35) | 131211 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 348409 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 33871 | 9.7% |
| a | 33689 | 9.7% |
| 30304 | 8.7% | |
| e | 27577 | 7.9% |
| t | 18645 | 5.4% |
| i | 15523 | 4.5% |
| c | 15168 | 4.4% |
| s | 14436 | 4.1% |
| l | 14256 | 4.1% |
| o | 13729 | 3.9% |
| Other values (35) | 131211 |
membership_type
Text
Missing
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 43695 |
| Missing (%) | 87.4% |
| Memory size | 781.2 KiB |
Length
| Max length | 171 |
|---|---|
| Median length | 99 |
| Mean length | 23.1998414 |
| Min length | 17 |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Friend Membership |
|---|---|
| 2nd row | Ambassador Membership - Monthly |
| 3rd row | Friend Membership |
| 4th row | Gold Ambassador Membership |
| 5th row | Friend Membership |
| Value | Count | Frequency (%) |
| membership | 5873 | |
| friend | 4487 | |
| ambassador | 1275 | 6.9% |
| silver | 1213 | 6.6% |
| 1011 | 5.5% | |
| monthly | 896 | 4.9% |
| gold | 716 | 3.9% |
| young | 659 | 3.6% |
| musician's | 659 | 3.6% |
| pass | 576 | 3.1% |
| Other values (24) | 1077 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 17903 | |
| i | 13399 | 9.2% |
| r | 13052 | 8.9% |
| 12142 | 8.3% | |
| s | 11282 | 7.7% |
| M | 7428 | 5.1% |
| m | 7163 | 4.9% |
| b | 7148 | 4.9% |
| h | 6942 | 4.7% |
| n | 6794 | 4.6% |
| Other values (35) | 43022 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 146275 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 17903 | |
| i | 13399 | 9.2% |
| r | 13052 | 8.9% |
| 12142 | 8.3% | |
| s | 11282 | 7.7% |
| M | 7428 | 5.1% |
| m | 7163 | 4.9% |
| b | 7148 | 4.9% |
| h | 6942 | 4.7% |
| n | 6794 | 4.6% |
| Other values (35) | 43022 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 146275 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 17903 | |
| i | 13399 | 9.2% |
| r | 13052 | 8.9% |
| 12142 | 8.3% | |
| s | 11282 | 7.7% |
| M | 7428 | 5.1% |
| m | 7163 | 4.9% |
| b | 7148 | 4.9% |
| h | 6942 | 4.7% |
| n | 6794 | 4.6% |
| Other values (35) | 43022 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 146275 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 17903 | |
| i | 13399 | 9.2% |
| r | 13052 | 8.9% |
| 12142 | 8.3% | |
| s | 11282 | 7.7% |
| M | 7428 | 5.1% |
| m | 7163 | 4.9% |
| b | 7148 | 4.9% |
| h | 6942 | 4.7% |
| n | 6794 | 4.6% |
| Other values (35) | 43022 |
has_negative_tickets
Real number (ℝ)
Missing Skewed Zeros
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 28916 |
| Missing (%) | 57.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.001897173212 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 21044 |
| Zeros (%) | 42.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.04351624709 |
|---|---|
| Coefficient of variation (CV) | 22.93741384 |
| Kurtosis | 522.2260213 |
| Mean | 0.001897173212 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.89490082 |
| Sum | 40 |
| Variance | 0.001893663761 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 21044 | |
| 1 | 40 | 0.1% |
| (Missing) | 28916 |
| Value | Count | Frequency (%) |
| 0 | 21044 | |
| 1 | 40 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 40 | 0.1% |
| 0 | 21044 |
data_source
Text
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.70796 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EIFData_2017-2019 |
|---|---|
| 2nd row | EIFData_2017-2019 |
| 3rd row | EIFData_2017-2019 |
| 4th row | Transactions_2024 |
| 5th row | Transactions_2024 |
| Value | Count | Frequency (%) |
| transactions_2024 | 26701 | |
| eifdata_2017-2019 | 21084 | |
| basic_2019 | 1914 | 3.8% |
| perevent_2019 | 301 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 97785 | 11.7% |
| a | 97484 | 11.7% |
| 0 | 71084 | 8.5% |
| s | 55316 | 6.6% |
| n | 53703 | 6.4% |
| _ | 50000 | 6.0% |
| t | 48086 | 5.8% |
| 1 | 44383 | 5.3% |
| c | 28615 | 3.4% |
| i | 28615 | 3.4% |
| Other values (15) | 260327 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 835398 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 97785 | 11.7% |
| a | 97484 | 11.7% |
| 0 | 71084 | 8.5% |
| s | 55316 | 6.6% |
| n | 53703 | 6.4% |
| _ | 50000 | 6.0% |
| t | 48086 | 5.8% |
| 1 | 44383 | 5.3% |
| c | 28615 | 3.4% |
| i | 28615 | 3.4% |
| Other values (15) | 260327 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 835398 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 97785 | 11.7% |
| a | 97484 | 11.7% |
| 0 | 71084 | 8.5% |
| s | 55316 | 6.6% |
| n | 53703 | 6.4% |
| _ | 50000 | 6.0% |
| t | 48086 | 5.8% |
| 1 | 44383 | 5.3% |
| c | 28615 | 3.4% |
| i | 28615 | 3.4% |
| Other values (15) | 260327 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 835398 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 97785 | 11.7% |
| a | 97484 | 11.7% |
| 0 | 71084 | 8.5% |
| s | 55316 | 6.6% |
| n | 53703 | 6.4% |
| _ | 50000 | 6.0% |
| t | 48086 | 5.8% |
| 1 | 44383 | 5.3% |
| c | 28615 | 3.4% |
| i | 28615 | 3.4% |
| Other values (15) | 260327 |
year
Real number (ℝ)
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2021.22206 |
| Minimum | 2017 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 2017 |
|---|---|
| 5-th percentile | 2017 |
| Q1 | 2018 |
| median | 2024 |
| Q3 | 2024 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 7 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.030223259 |
|---|---|
| Coefficient of variation (CV) | 0.001499203536 |
| Kurtosis | -1.80389157 |
| Mean | 2021.22206 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.2458303365 |
| Sum | 101061103 |
| Variance | 9.182253001 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2024 | 26701 | |
| 2019 | 8924 | 17.8% |
| 2017 | 8027 | 16.1% |
| 2018 | 6348 | 12.7% |
| Value | Count | Frequency (%) |
| 2017 | 8027 | 16.1% |
| 2018 | 6348 | 12.7% |
| 2019 | 8924 | 17.8% |
| 2024 | 26701 |
| Value | Count | Frequency (%) |
| 2024 | 26701 | |
| 2019 | 8924 | 17.8% |
| 2018 | 6348 | 12.7% |
| 2017 | 8027 | 16.1% |
month
Real number (ℝ)
Skewed
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.99754 |
| Minimum | 7 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 781.2 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 8 |
| median | 8 |
| Q3 | 8 |
| 95-th percentile | 8 |
| Maximum | 8 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.04953783887 |
|---|---|
| Coefficient of variation (CV) | 0.006194134555 |
| Kurtosis | 401.5468047 |
| Mean | 7.99754 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -20.08807464 |
| Sum | 399877 |
| Variance | 0.00245399748 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 49877 | |
| 7 | 123 | 0.2% |
| Value | Count | Frequency (%) |
| 7 | 123 | 0.2% |
| 8 | 49877 |
| Value | Count | Frequency (%) |
| 8 | 49877 | |
| 7 | 123 | 0.2% |
month_name
Text
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.2 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.99508 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | August |
|---|---|
| 2nd row | August |
| 3rd row | August |
| 4th row | August |
| 5th row | August |
| Value | Count | Frequency (%) |
| august | 49877 | |
| july | 123 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 99877 | |
| A | 49877 | |
| g | 49877 | |
| s | 49877 | |
| t | 49877 | |
| J | 123 | < 0.1% |
| l | 123 | < 0.1% |
| y | 123 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 299754 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 99877 | |
| A | 49877 | |
| g | 49877 | |
| s | 49877 | |
| t | 49877 | |
| J | 123 | < 0.1% |
| l | 123 | < 0.1% |
| y | 123 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 299754 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 99877 | |
| A | 49877 | |
| g | 49877 | |
| s | 49877 | |
| t | 49877 | |
| J | 123 | < 0.1% |
| l | 123 | < 0.1% |
| y | 123 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 299754 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 99877 | |
| A | 49877 | |
| g | 49877 | |
| s | 49877 | |
| t | 49877 | |
| J | 123 | < 0.1% |
| l | 123 | < 0.1% |
| y | 123 | < 0.1% |